SELECT * from TABLE where CODE IS NULL OR CODE!='C'
SELECT contactname, IFNULL(bizphone, homephone) phone FROM contacts;